MySQL Pocket Reference, 2nd Edition by George Reese

Author:George Reese [George Reese]
Language: eng
Format: epub, mobi
Tags: COMPUTERS / Data Processing
ISBN: 9780596102913
Publisher: O'Reilly Media
Published: 2009-02-08T16:00:00+00:00

Example

EXPLAIN SELECT customer.name, product.name FROM customer, product, purchases WHERE purchases.customer=customer.id AND purchases. product=product.id

FETCH

FETCH cursor_name INTO var [,...]

Fetches the next row of data from an open cursor and advances the cursor one row. To detect when no more rows are available, you need to set up a handler to catch SQL state 02000 (NO DATA).

FLUSH

FLUSH option[, option...]

Flushes or resets various internal processes depending on the options given. You must have RELOAD privileges to execute this statement. The option can be any of the following:

DES_KEY_FILE

Reloads the DES keys from the file originally specified with the --des-key-file option.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.